<%--
  Created by IntelliJ IDEA.
  User: yuan
  Date: 2019/3/29
  Time: 17:16
  To change this template use File | Settings | File Templates.
--%>
<%@ page import="java.util.Date" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%
    session.setAttribute("rootPath",request.getContextPath());
%>
<html>

<head>
    <base href="${sessionScope.rootPath}/"/>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">

    <title>可搜索加密数据库系统</title>

    <link href="css/bootstrap.min.css" rel="stylesheet">
    <link href="font-awesome/css/font-awesome.css" rel="stylesheet">

    <!-- Toastr style -->
    <link href="css/plugins/toastr/toastr.min.css" rel="stylesheet">

    <!-- Gritter -->
    <link href="js/plugins/gritter/jquery.gritter.css" rel="stylesheet">

    <link href="css/animate.css" rel="stylesheet">
    <link href="css/style.css" rel="stylesheet">


    <link href="css/plugins/codemirror/codemirror.css" rel="stylesheet">
    <link href="css/plugins/codemirror/ambiance.css" rel="stylesheet">

</head>

<body>
<div id="wrapper">
    <!-- 左侧导航栏 -->
    <nav class="navbar-default navbar-static-side" role="navigation">
        <div class="sidebar-collapse">
            <ul class="nav metismenu" id="side-menu">

                <!-- 用户信息 -->
                <li class="nav-header">
                    <div class="dropdown profile-element"> <span>
                        <img alt="image" class="img-circle" src="img/admin.jpg" width="50" height="50" />
                    </span>
                        <a data-toggle="dropdown" class="dropdown-toggle" href="#">
                            <span class="clear">
                                <span class="block m-t-xs">
                                    <strong class="font-bold">${sessionScope.logUser.userName}</strong>
                             </span>
                            </span>
                        </a>

                    </div>
                    <div class="logo-element">
                        IN+
                    </div>
                </li>

                <!-- 导航链接 -->
                <c:if test="${logUser.userName != null}">
                    <li>
                        <a href="newTable.jsp">
                            <i class="fa fa-th-large"></i>
                            <span class="nav-label">创建新表</span> <%--<span class="fa arrow"></span>--%>
                        </a>
                    </li>
                </c:if>
                <c:if test="${logUser.userName != null}">
                    <li>
                        <a href="operatingTable.jsp">
                            <i class="fa fa-th-large"></i>
                            <span class="nav-label">操作数据</span> <%--<span class="fa arrow"></span>--%>
                        </a>
                    </li>
                </c:if>
                <c:if test="${logUser.userName != null}">
                    <li>
                        <a href="selectTable.jsp">
                            <i class="fa fa-th-large"></i>
                            <span class="nav-label">自由查询</span> <%--<span class="fa arrow"></span>--%>
                        </a>
                    </li>
                </c:if>

                <%-- <li>
                     <a href="index.jsp"><i class="fa fa-th-large"></i> <span class="nav-label">考卷管理</span> <span class="fa arrow"></span></a>
                     <ul class="nav nav-second-level">
                         <c:if test="${logUser.userName == null}">
                             <li class="active"><a href="">考试</a></li>
                         </c:if>
                         <c:if test="${logUser.userName != null}">
                             <li><a href="">考卷维护</a></li>
                         </c:if>
                     </ul>
                 </li>--%>
                <%-- <li>
                     <a href="index.jsp"><i class="fa fa-th-large"></i> <span class="nav-label">用户管理</span> <span class="fa arrow"></span></a>
                     <ul class="nav nav-second-level">
                         <c:if test="${logUser.userName !=null}">
                             <li class="active"><a href="">批量导入用户</a></li>
                         </c:if>
                         <c:if test="${logUser.userName == null}">
                             <li><a href="">修改用户信息</a></li>
                         </c:if>
                     </ul>
                 </li>--%>
            </ul>
        </div>
    </nav>
    <div id="page-wrapper" class="gray-bg">
        <div class="row border-bottom">
            <nav class="navbar navbar-static-top" role="navigation" style="margin-bottom: 0">
                <%--<div class="navbar-header">
                    <a class="navbar-minimalize minimalize-styl-2 btn btn-primary " href="#"><i class="fa fa-bars"></i> </a>
                    <form role="search" class="navbar-form-custom" action="search_results.html">
                        <div class="form-group">
                            <input type="text" placeholder="Search for something..." class="form-control" name="top-search" id="top-search">
                        </div>
                    </form>
                </div>--%>
                <ul class="nav navbar-top-links navbar-right">
                    <li>
                        <span class="m-r-sm text-muted welcome-message">${loginUser.userName}欢迎登陆</span>
                    </li>
                    <li>
                        <a href="login.jsp">
                            <i class="fa fa-sign-out"></i> 注销
                        </a>
                    </li>
                </ul>
            </nav>
        </div>
        <div class="row wrapper border-bottom white-bg page-heading">
            <div class="col-lg-9">
                <h2>自由查询</h2>
                <ol class="breadcrumb">
                    <li>
                        <a href="index.jsp">首页</a>
                    </li>
                </ol>
            </div>
        </div>

        <div class="wrapper wrapper-content animated fadeIn">
            <div class="row">
                <div class="col-lg-12">
                    <div class="ibox">
                        <div class="ibox-content">
                            <div class="row">
                                <div class="col-lg-12">
                                    <div class="panel panel-default">
                                        <div class="panel-heading">
                                            自由查询
                                        </div>
                                        <%--<div class="panel-body">
                                            <div class="widget red-bg p-lg text-center">
                                                <div class="m-b-md">
                                                    <i class="fa fa-bell fa-4x"></i>
                                                    <h1 class="m-xs">欢迎登陆</h1>
                                                    <h3 class="font-bold no-margins">
                                                        可搜索加密数据库系统
                                                    </h3>
                                                    <small>登陆时间<%= new Date()%></small>
                                                </div>
                                            </div>
                                        </div>--%>
                                        <div class="panel-body">
                                            <form role="form" action="select/selectTable" method="post">
                                                <div class="form-group">
                                                    <label for="stem">请输入sql语句：</label>
                                                    <textarea class="form-control" rows="5" id="stem" name="question" required=""></textarea>
                                                </div>
                                                <%--<div class="form-group">
                                                    <label for="answer">*参考答案：</label>
                                                    <textarea class="form-control" rows="3" id="answer" name="stdAnswer" required=""></textarea>
                                                </div>--%>
                                                <br>
                                                <br>
                                                <div class="form-group" >
                                                    <div class="inline col-lg-offset-6">
                                                        <button type="submit" class="btn btn-primary btn-lg">查询</button>
                                                    </div>
                                                </div>

                                            </form>
                                        </div>


                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="footer">
            <div class="pull-right">
                毕设小组
            </div>
            <div>
                <strong>西华</strong> 可搜索加密数据库系统 &copy; 2019
            </div>
        </div>
    </div>
</div>
<!-- Mainly scripts -->
<script src="js/jquery-2.1.1.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/plugins/metisMenu/jquery.metisMenu.js"></script>
<script src="js/plugins/slimscroll/jquery.slimscroll.min.js"></script>

<!-- Custom and plugin javascript -->

<script src="js/inspinia.js"></script>
<script src="js/plugins/pace/pace.min.js"></script>

<!-- Toastr -->
<script src="js/plugins/toastr/toastr.min.js"></script>


<%--
    <!-- Flot -->
    <script src="vendor/js/plugins/flot/jquery.flot.js"></script>
    <script src="vendor/js/plugins/flot/jquery.flot.tooltip.min.js"></script>
    <script src="vendor/js/plugins/flot/jquery.flot.spline.js"></script>
    <script src="vendor/js/plugins/flot/jquery.flot.resize.js"></script>
    <script src="vendor/js/plugins/flot/jquery.flot.pie.js"></script>

    <!-- Peity -->
    <script src="vendor/js/plugins/peity/jquery.peity.min.js"></script>
    <script src="vendor/js/demo/peity-demo.js"></script>

    <!-- jQuery UI -->
    <script src="vendor/js/plugins/jquery-ui/jquery-ui.min.js"></script>

    <!-- GITTER -->
    <script src="vendor/js/plugins/gritter/jquery.gritter.min.js"></script>

    <!-- Sparkline -->
    <script src="vendor/js/plugins/sparkline/jquery.sparkline.min.js"></script>

    <!-- Sparkline demo data  -->
    <script src="vendor/js/demo/sparkline-demo.js"></script>

    <!-- ChartJS-->
    <script src="vendor/js/plugins/chartJs/Chart.min.js"></script>
    --%>



<script>
    $(document).ready(function() {
        setTimeout(function() {
            toastr.options = {
                closeButton: true,
                progressBar: true,
                showMethod: 'slideDown',
                timeOut: 4000
            };
            toastr.success('Responsive Admin Theme', '自由查询');

        }, 1300);
    });
</script>
</body>
</html>

